Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

Indexes

OpenEdge DataServers allow non-OpenEdge database views to be used in an OpenEdge environment. Generally, a view does not need an index when accessed with the 4GL. A view is treated as a read-only table.

Progress Dynamics requires that each table have an index. One reason for this requirement is that Progress Dynamics makes extensive use of ROWID. To use a view in Progress Dynamics, you must add an index to the schema holder for the view. If an index is not added to the schema holder, the view can still be used as a table. However, the data from the view is not displayed.

You can also use a OpenEdge DataServer to access a non-OpenEdge database table that does not have an index defined. For the same reason, you would have similar problems accessing this data. To see the data in such a table using Progress Dynamics, you must add an index.